| Key Name |
Key Type |
Keys |
| SyStudentInquiry_AmRepID_N_N_IDX |
Inversion Entry |
AssignedAdmissionsRepId |
| SyStudentInquiry_AmLeadTypeID_N_N_IDX |
Inversion Entry |
LeadTypeId |
| SyStudentInquiry_AmLeadSrcID_N_N_IDX |
Inversion Entry |
LeadSourceId |
| SyStudentInquiry_AdProgramID_N_N_IDX |
Inversion Entry |
ProgramId |
| SyStudentInquiry_UserID_N_N_IDX |
Inversion Entry |
LastModifiedUserId |
| SyStudentInquiry_SyCampusID_N_N_IDX |
Inversion Entry |
CampusId |
| SyStudentInquiry_OriginalAmRepID_N_N_IDX |
Inversion Entry |
OriginalAssignedAdmissionsRepId |
| SyStudentInquiry_AmRepTypeID_N_N_IDX |
Inversion Entry |
AdmissionsRepTypeId |
| SyStudentInquiry_AdProgramGroupID_N_N_IDX |
Inversion Entry |
ProgramGroupId |
| SyStudentInquiry_SyStudentInquiryID_U_C_IDX |
PrimaryKey |
ProspectInquiryId |
| SyStudentInquiry_SyStudentID_Current_SyStudentInquiryID_U_N_IDX |
Alternate Key |
IsCurrentInquiry, ProspectInquiryId |
| Entity Name |
Type |
Cardinality |
Business Name |
VerbPhrase |
InversePhrase |
Foreign Keys |
Is Supertype |
| Campus |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CampusId |
NO |
| ProgramGroup |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
ProgramGroupId |
NO |
| Program |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
ProgramId |
NO |
| LeadSource |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
LeadSourceId |
NO |
| LeadType |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
LeadTypeId |
NO |
| Staff |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
AssignedAdmissionsRepId |
NO |
| AdmissionsRepType |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
AdmissionsRepTypeId |
NO |
| Staff |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
OriginalAssignedAdmissionsRepId |
NO |
| Campus |
Non-Identifying |
One To Zero or More |
|
|
|
CampusId |
NO |
| Staff |
Non-Identifying |
One To Zero or More |
|
|
|
LastModifiedUserId |
NO |
| LeadSource |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
LeadSourceId |
NO |
| LeadType |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
LeadTypeId |
NO |